---
title: OLEDBErrors Object (Excel)
keywords: vbaxl10.chm655072
f1_keywords:
- vbaxl10.chm655072
ms.prod: excel
api_name:
- Excel.OLEDBErrors
ms.assetid: 0e48697d-4f65-b544-4487-24a9fd2b81b6
ms.date: 06/08/2017
---


# OLEDBErrors Object (Excel)

A collection of  **[OLEDBError](oledberror-object-excel.md)** objects.


## Remarks

 Each **OLEDBError** object represents an error returned by the most recent OLE DB query. If the specified OLE DB query runs without error, the **OLEDBErrors** collection is empty. The errors in the collection are indexed in the order in which they're generated by the OLE DB provider. You cannot add members to the collection.


## Example

Use the  **[OLEDBErrors](application-oledberrors-property-excel.md)** property to return the **OLEDBErrors** collection. The following example displays the error description and the **[SqlState](oledberror-sqlstate-property-excel.md)** property's value for each OLE DB error in the collection.


```vb
For Each objEr in Application.OLEDBErrors 
 MsgBox "The following error occurred:" &; _ 
 objEr.ErrorString &; " : " &; objEr.SqlState 
Next objEr
```

Use  **OLEDBErrors** ( _index_ ), where _index_ is the index number of the OLE DB error, to return a single **OLEDBError** object. The following example displays the error description and the **SqlState** property's value for the first error returned by the most recent OLE DB query.




```vb
Set objEr = Application.OLEDBErrors(1) 
MsgBox "The following error occurred:" &; _ 
 objEr.ErrorString &; " : " &; objEr.SqlState
```


## See also


#### Other resources



[Excel Object Model Reference](http://msdn.microsoft.com/library/11ea8598-8a20-92d5-f98b-0da04263bf2c%28Office.15%29.aspx)

